{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Request for Cash","Consolidated Support","CAPER FY21","CAPER FY21 Cum","CAPERList"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":6,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Request for Cash","index":0,"n_rows":65,"n_cols":9,"rows_kept":65,"cut":false,"hidden":false,"merged":[[33,0,33,9],[45,0,45,1],[45,8,45,9],[34,0,36,9],[38,8,38,9],[39,6,39,7],[39,8,39,9],[38,6,38,7],[38,1,38,2],[40,6,40,7],[43,0,43,9],[44,0,44,1],[44,8,44,9],[40,1,40,3],[30,0,32,9],[4,7,4,9],[5,7,5,9],[6,7,6,9],[10,1,10,3],[4,4,4,6],[9,1,9,3],[7,1,7,3],[8,1,8,3],[27,0,27,9],[26,0,26,9],[3,1,3,3],[10,7,10,9],[5,1,5,3],[6,1,6,3],[6,5,6,6],[7,7,7,9],[8,7,8,9],[9,7,9,9]]}
["Mississippi Home Corporation"]
["Request for Cash"]
[]
["Program:","Emergency Solutions Grant Program"]
["Section A:  General Information",null,null,null,"Section B:  Project Information"]
["Recipient",null,null,null,"Grant No.","Contract No.",null,"Project No."]
["Mailing Address",{"$f":"LOOKUP(+$B$6,C52:C65,D52:D65)","v":{"$error":"#N/A"}},null,null,{"$f":"LOOKUP(+$B$6,C52:C65,H52:H65)","v":{"$error":"#N/A"}},{"$f":"LOOKUP(+$B$6,C52:C65,I52:I65)","v":{"$error":"#N/A"}}]
["Street Address",{"$f":"LOOKUP(+$B$6,C52:C65,E52:E65)","v":{"$error":"#N/A"}},null,null,"Services Rendered",null,null,"Request No."]
["City, State Zip",{"$f":"LOOKUP(+$B$6,C52:C65,F52:F65)","v":{"$error":"#N/A"}},null,null,"From",null,"To"]
["Telephone No.",{"$f":"LOOKUP(+$B$6,C52:C65,G52:G65)","v":{"$error":"#N/A"}},null,null,null,"Thru",null,"MHC Staff Initials"]
[]
["Section C:  Request Per Activity"]
[null,null,"Activity Description"," Budget Amount","Total Prior Request to Date","This Request","Remaining Balance",null,"Activity Numbers"]
[1,null,{"$f":"+'Consolidated Support'!B46","v":"Shelter"},{"$f":"+'Consolidated Support'!I46","v":0},{"$f":"+'Consolidated Support'!J8","v":0},{"$f":"+'Consolidated Support'!G46","v":0},{"$f":"+D14-E14-F14","v":0},null,15562]
[2,null,"Street Outreach",{"$f":"+'Consolidated Support'!I59","v":0},{"$f":"+'Consolidated Support'!J48","v":0},{"$f":"+'Consolidated Support'!G59","v":0},0,null,15560]
[3,null,"Rapid Rehousing",{"$f":"+'Consolidated Support'!I83","v":0},{"$f":"+'Consolidated Support'!J61","v":0},{"$f":"+'Consolidated Support'!G83","v":0},0,null,15561]
[4,null,"Homeless Prevention",{"$f":"'Consolidated Support'!I107","v":0},{"$f":"+'Consolidated Support'!J85","v":0},{"$f":"'Consolidated Support'!G107","v":0},0,null,15563]
[5,null,"HMIS",{"$f":"'Consolidated Support'!I120","v":0},{"$f":"+'Consolidated Support'!J109","v":0},{"$f":"'Consolidated Support'!G120","v":0},0,null,15564]
[16,null,null,null,null,null,{"$f":"+D20-E20-F20","v":0}]
[17,null,null,null,null,null,0]
[18,null,null,null,null,null,0]
[20]
[20,null,null,null,null,null,{"$f":"+D23-E23-F23","v":0}]
[null,null,"Total:",{"$f":"SUM(D14:D23)","v":0},{"$f":"SUM(E14:E23)","v":0},{"$f":"SUM(F14:F23)","v":0},{"$f":"SUM(G14:G23)","v":0}]
[]
[]
["Required Accomplishment Narrative "]
[]
[]
[]
["   I Hereby Certify That (a) the services covered by this request have not been received from the Federal Government/State Government or expended for such services under any other contract agreement or grant; (b) the amount requested will be expended for allowable costs / expenditures under the terms of the contract agreement or grant; (c) the amount requested herein does not exceed the total funds obligated by contract; and (d) the funds are requested for only immediate disbursements.  "]
[]
[]
[" By signing this report, I certify to the best of my knowledge and belief that the report is true, complete, and accurate, and the expenditures, disbursements and cash receipts are for the purposes and objectives set forth in the terms and conditions of the Federal award.  I am aware that any false, fictitious, or fraudulent information, or the omission of any material fact, may subject me to criminal, civil or administrative penalties for fraud, false statements, false claims or otherwise (U.S. Code Title 18, Section 1001 and Title 31, Sections 3729-3730 and 3801-3812)."]
["   I Hereby Certify That the goods sold and/or services rendered have been delivered and/or performed in good order within the time listed above and are in compliance with all statutory requirements and regulations.  I certify that this request does not include any advances or funds for future obligations. "]
[]
[]
["Is this your final request for cash on this contract?",null,null,null,null,"YES",null,"NO"]
[]
[null,"           Signature of Authorized Official ",null,null,"Date Signed",null," Prepared By",null,"Date Prepared"]
[]
[null,"Typed Name and Title of Authorized Official",null,null,null,null,"Preparer's Telephone No."]
[]
[]
["IDIS Voucher Number",null,"Vendor Number","Issue/Series","Fund/Sub-Fund","Serviceer"]
[]
[]
[]
[]
[]
[null,null,"Applicant","Mailing Address","Street Address","City","Phone #","Grant No.","Contract No."]
[null,null,"Back Bay Mission",null,"1012 Division Street","Biloxi, MS 39530","(228) 432-0301",2021,"2021-ESG-BBM-21"]
[null,null,"Care Lodge Domestic Violence Shelter","P O Box 5331",null,"Meridian, MS 39302",6014828720,2021,"2021-ESG-CareLodge-21"]
[null,null,"Center for Violence Prevention","PO Box 6279",null,"Pearl, MS 39288 ","(601) 932-4208",2021,"2021-ESG-CVP-21"]
[null,null,"Community Care Network ",null,"7400 Fountainblue Road","Ocean Springs, MS 39564",2282202987,2021,"2021-ESG-CCN-21"]
[null,null,"Community Counseling Services ","P O Box 2590",null,"Columbus, MS 39704",6623294333,2021,"2021-ESG-CCS-21"]
[null,null,"Domestic Abuse Familly Service","P O Box 273",null,"Laura, MS 39441",6013422362,2021,"2021-ESG-DAFS-21"]
[null,null,"Gulf Coast Center for Non-violence ","P O Box 333",null,"Biloxi, Mississippi 39533",2284363809,2021,"2021-ESG-GCWC-21"]
[null,null,"Hancock Resource Center ",null,"454 Highway 90, Suite B","Waveland, MS 39576",2284638887,2021,"2021-ESG-HRC-21"]
[null,null,"Multi County ","P O Box 905",null,"Meridian, MS 39302",6014834838,2021,"2021-ESG-MCCSA-21"]
[null,null,"MUTEH ",null,"201 W. Capitol St., Suite 800","Jackson, MS 39202",6019600557,2021,"2021-ESG-MUTEH-21"]
[null,null,"Open Door Homeless Coalititon",null,"12075 Seaway Road B-220","Gulfport, MS 39503","(228) 604-2048",2021,"2021-ESG-ODHC-21"]
[null,null,"S. A. F. E. ","P O Box 985",null,"Tupelo, MS 38804",6628420105,2021,"2021-ESG-SAFE-21"]
[null,null,"The Salvation Army-Gulf Coast",null,"575 Division Street","Biloxi, MS 39531",2283263676,2021,"2021-ESG-SAGC-21"]
[null,null,"WWISCAA, Inc",null,"1538 Old Leland Road","Greenville, MS 38701",6623785857,2021,"2021-ESG-WWISCAA-21"]

{"sheet":"Consolidated Support","index":1,"n_rows":148,"n_cols":11,"rows_kept":148,"cut":false,"hidden":false,"merged":[[129,1,129,3],[147,1,147,3],[146,1,146,3],[146,7,146,8],[136,0,138,10],[140,0,141,10],[131,4,131,5],[134,5,134,6],[133,5,133,6],[144,7,144,8],[145,7,145,8],[142,0,142,10]]}
["Mississippi Home Corporation"]
[" Consolidated Support Sheet"]
[null,"Program:",{"$f":"+'Request for Cash'!B4","v":"Emergency Solutions Grant Program"}]
[null,"Recipient",{"$f":"+'Request for Cash'!B6","v":0},null,null,null,null,"Contract Number:",{"$f":"+'Request for Cash'!F7","v":{"$error":"#N/A"}}]
[null,"Request for Cash Number:",{"$f":"+'Request for Cash'!H9","v":0},null,null,null,null,"Total Amount Requested:",{"$f":"+'Request for Cash'!F24","v":0}]
[]
["IDIS #/  AWARD #","Line Items","CAPER Category","Vendor","Invoice #","Total Invoice","Amount of This Request","Match","Amount Budgeted","Amount Requested to Date","Balance"]
[{"$f":"+'Request for Cash'!I14","v":15562},"Shelter",null,null,null,null,null,null,null,null,{"$f":"+I8-J8","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"+G9","v":0},{"$f":"+I9-J9","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"+G10","v":0},0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,{"$f":"+B8","v":"Shelter"},null,null,null,{"$f":"SUM(F8:F45)","v":0},0,0,0,0,0]
[]
[{"$f":"+'Request for Cash'!I15","v":15560},"Street Outreach",null,null,null,null,null,null,null,0,{"$f":"+I48-J48","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"+G49","v":0},0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,{"$f":"+B48","v":"Street Outreach"},null,null,null,{"$f":"SUM(F48:F58)","v":0},0,0,0,0,0]
[]
[{"$f":"+'Request for Cash'!I16","v":15561},"Rapid Re-Housing",null,null,null,null,null,null,null,0,{"$f":"+I61-J61","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"+G62","v":0},0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,{"$f":"B61","v":"Rapid Re-Housing"},null,null,null,{"$f":"SUM(F61:F82)","v":0},0,0,0,0,0]
[]
[{"$f":"+'Request for Cash'!I17","v":15563},"Homeless Prevention",null,null,null,null,null,null,null,0,{"$f":"+I85-J85","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"+G86","v":0},0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,{"$f":"+B85","v":"Homeless Prevention"},null,null,null,{"$f":"SUM(F85:F106)","v":0},0,0,0,0,0]
[]
[{"$f":"+'Request for Cash'!I18","v":15564},"HMIS",null,null,null,null,null,null,null,0,{"$f":"+I109-J109","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"+G110","v":0},0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,{"$f":"+B109","v":"HMIS"},null,null,null,{"$f":"SUM(F109:F119)","v":0},0,0,0,0,0]
[]
[null,"MATCH"]
[]
[]
[]
[]
[]
[null,{"$f":"+B122","v":"MATCH"},null,null,null,null,null,{"$f":"SUM(H117:H127)","v":0}]
[]
[null,"GRAND TOTAL",null,null,null,{"$f":"F59+F120+F107+F83+F46","v":0},{"$f":"G59+G120+G107+G83+G46","v":0},{"$f":"+H128","v":0},{"$f":"I59+I120+I107+I83+I46","v":0},{"$f":"J59+J120+J107+J83+J46","v":0},{"$f":"K59+K120+K107+K83+K46","v":0}]
[]
[null,"Services Rendered - Beginning:",null,null,{"$f":"'Request for Cash'!E10","v":"00:00:00"},null,"Thru",{"$f":"+'Request for Cash'!G10","v":"00:00:00"}]
[]
[null,null,null,{"$f":"+J130","v":0},"Plus (+)",{"$f":"+H130","v":0},null,"Equals (=)",{"$f":"+D134+F134","v":0}]
[null,"Cumulative:  ",null,"Program Expenditures ",null,"Matching Expenditures",null,null,"Total Expenditures"]
[]
["   I Hereby Certify That (a) the services covered by this request have not been received from the Federal / State Government or expended for such services under any other contract agreement or grant; (b) the amount requested will be expended for allowable costs / expenditures under the terms of the contract agreement or grant; (c) the amount requested herein does not exceed the total funds obligated by contract; and (d) the funds are requested for only immediate disbursements."]
[]
[]
[]
["   I Hereby Certify That the goods sold and/or services rendered have been delivered and/or performed in good order within the time listed above and are in compliance with all statutory requirements and regulations.  I certify that this request does not include any advances or funds for future obligations."]
[]
[" By signing this report, I certify to the best of my knowledge and belief that the report is true, complete, and accurate, and the expenditures, disbursements and cash receipts are for the purposes and objectives set forth in the terms and conditions of the Federal award.  I am aware that any false, fictitious, or fraudulent information, or the omission of any material fact, may subject me to criminal, civil or administrative penalties for fraud, false statements, false claims or otherwise (U.S. Code Title 18, Section 1001 and Title 31, Sections 3729-3730 and 3801-3812)."]
[]
[null,null,null,null,null,{"$f":"+'Request for Cash'!E39","v":"00:00:00"},null,{"$f":"+'Request for Cash'!G39","v":0}]
[null,"Signature of Authorized Official ",null,null,null,"Date Signed",null," Prepared By"]
[null,{"$f":"+'Request for Cash'!B41","v":0},null,null," ",null,null,{"$f":"+'Request for Cash'!G41","v":0}]
[null,"          Typed Name and Title of Authorized Official",null,null,null,null,null,"Preparer's Telephone No."]

{"sheet":"CAPER FY21","index":2,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[[5,1,5,2],[0,0,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[24,0,24,2],[7,0,7,2],[12,0,12,2],[18,0,18,2],[31,0,31,2]]}
[" Financial Summary Report (CAPER)"]
["Sub recipient",{"$f":"+'Request for Cash'!B6","v":0}]
["Contract Number",{"$f":"+'Request for Cash'!F7","v":{"$error":"#N/A"}}]
["Request for Cash Number",{"$f":"'Request for Cash'!H9","v":0}]
["Reporting Period From",{"$f":"'Request for Cash'!E10","v":"00:00:00"}]
["                            To",{"$f":"'Request for Cash'!G10","v":"00:00:00"}]
[null,null,"Emergency Solutions Grant Expenditures by Categories "]
["ESG Expenditures for Emergency Shelter"]
["Essential Services",null,{"$f":"SUMIF('Consolidated Support'!C9:C45,\"ESES*\",'Consolidated Support'!J9:J45)","v":0}]
["Operations",null,{"$f":"SUMIF('Consolidated Support'!C9:C45,\"ESOP*\",'Consolidated Support'!J9:J45)","v":0}]
["Subtotal",null,{"$f":"SUM(C9:C10)","v":0}]
[]
["ESG Expenditures for Rapid Rehousing"]
["Expenditures for Rental Assistance",null,{"$f":"SUMIF('Consolidated Support'!C62:C82,\"RRRA*\",'Consolidated Support'!J62:J82)","v":0}]
["Expenditures for Housing Relocation and Stabilization Services - Financial Assistance",null,{"$f":"SUMIF('Consolidated Support'!C62:C82,\"RRFA*\",'Consolidated Support'!J62:J82)","v":0}]
["Expenditures for Housing Relocation and Stabilization Services - Services",null,{"$f":"SUMIF('Consolidated Support'!C62:C82,\"RRSS*\",'Consolidated Support'!J62:J82)","v":0}]
["Subtotal Rapid Rehousing",null,{"$f":"SUM(C14:C16)","v":0}]
[]
["ESG Expenditures for Homelessness Prevention"]
["Expenditures for Rental Assistance",null,{"$f":"SUMIF('Consolidated Support'!C86:C106,\"HPRA*\",'Consolidated Support'!J86:J106)","v":0}]
["Expenditures for Housing Relocation and Stabilization Services - Financial Assistance",null,{"$f":"SUMIF('Consolidated Support'!C86:C106,\"HPFA*\",'Consolidated Support'!J86:J106)","v":0}]
["Expenditures for Housing Relocation and Stabilization Services - Services",null,{"$f":"SUMIF('Consolidated Support'!C86:C106,\"HPSS*\",'Consolidated Support'!J86:J106)","v":0}]
["Subtotal Homelessness Prevention",null,{"$f":"SUM(C20:C22)","v":0}]
[]
["Other Grant Expenditures"]
["Street Outreach",null,{"$f":"SUMIF('Consolidated Support'!C49:C58,\"SOES*\",'Consolidated Support'!J49:J58)","v":0}]
["HMIS",null,{"$f":"SUMIF('Consolidated Support'!C110:C119,\"HMIS*\",'Consolidated Support'!J110:J119)","v":0}]
["Administration"]
[]
["Total ESG Grant Funds",null,{"$f":"+C28+C27+C26+C11+C17+C23","v":0}]
[]
["Match Source"]
["Other Non-ESG HUD funds",null,{"$f":"SUMIF('Consolidated Support'!C123:C127,\"MATCH-Other Non-ESG Funds*\",'Consolidated Support'!H123:H127)","v":0}]
["Other Federal Funds",null,{"$f":"SUMIF('Consolidated Support'!C123:C127,\"MATCH-Other Federal Funds*\",'Consolidated Support'!H123:H127)","v":0}]
["State Government ",null,{"$f":"SUMIF('Consolidated Support'!C123:C127,\"MATCH-State Government*\",'Consolidated Support'!H123:H127)","v":0}]
["Local Government ",null,{"$f":"SUMIF('Consolidated Support'!C123:C127,\"MATCH-Local Government*\",'Consolidated Support'!H123:H127)","v":0}]
["Private Funds",null,{"$f":"SUMIF('Consolidated Support'!C123:C127,\"MATCH-Private Funds*\",'Consolidated Support'!H123:H127)","v":0}]
["Other Volunteer Hours",null,{"$f":"SUMIF('Consolidated Support'!C123:C127,\"MATCH-Other Volunteer Hours*\",'Consolidated Support'!H123:H127)","v":0}]
["Other In-Kind",null,{"$f":"SUMIF('Consolidated Support'!C123:C127,\"MATCH-In-Kind Donations*\",'Consolidated Support'!H123:H127)","v":0}]
["Other-Donated value___________________________________",null,{"$f":"SUMIF('Consolidated Support'!C123:C127,\"MATCH-Other-Donated value*\",'Consolidated Support'!H123:H127)","v":0}]
["Total Match Amount",null,{"$f":"SUM(C33:C40)","v":0}]
[]
["Total ESG Funds Expended",null,{"$f":"+C41+C30","v":0}]

{"sheet":"CAPER FY21 Cum","index":3,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[[31,0,31,2],[0,0,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[7,0,7,2],[12,0,12,2],[18,0,18,2],[24,0,24,2]]}
["Cumulative Financial Summary Report (CAPER)"]
["Sub recipient",{"$f":"'Request for Cash'!B6:D6","v":0}]
["Contract Number",{"$f":"'Request for Cash'!F7","v":{"$error":"#N/A"}}]
["Request for Cash Number",{"$f":"'Consolidated Support'!C5","v":0}]
["Reporting Period From",{"$f":"'Request for Cash'!E10","v":"00:00:00"}]
["                            To",{"$f":"'Request for Cash'!G10","v":"00:00:00"}]
[null,null,"Emergency Solutions Grant Expenditures by Categories    9/01/21 - 8/31/22"]
["ESG Expenditures for Emergency Shelter"]
["Essential Services",null,0]
["Operations",null,0]
["Subtotal",null,{"$f":"SUM(C9:C10)","v":0}]
[]
["ESG Expenditures for Rapid Rehousing"]
["Expenditures for Rental Assistance",null,0]
["Expenditures for Housing Relocation and Stabilization Services - Financial Assistance",null,0]
["Expenditures for Housing Relocation and Stabilization Services - Services",null,0]
["Subtotal Rapid Rehousing",null,{"$f":"SUM(C14:C16)","v":0}]
[]
["ESG Expenditures for Homelessness Prevention"]
["Expenditures for Rental Assistance",null,0]
["Expenditures for Housing Relocation and Stabilization Services - Financial Assistance",null,0]
["Expenditures for Housing Relocation and Stabilization Services - Services",null,0]
["Subtotal Homelessness Prevention",null,{"$f":"SUM(C20:C22)","v":0}]
[]
["Other Grant Expenditures"]
["Street Outreach",null,0]
["HMIS",null,0]
["Administration",null,0]
[]
["Total ESG Grant Funds",null,{"$f":"+C28+C27+C26+C11+C17+C23","v":0}]
[]
["Match Source"]
["Other Non-ESG HUD funds",null,0]
["Other Federal Funds",null,0]
["State Government ",null,0]
["Local Government ",null,0]
["Private Funds",null,0]
["Other Volunteer Hours",null,0]
["Other In-Kind",null,0]
["Other Type___________________________________",null,0]
["Total Match Amount",null,{"$f":"SUM(C33:C40)","v":0}]
[]
["Total ESG Funds Expended",null,{"$f":"+C41+C30","v":0}]

{"sheet":"CAPERList","index":4,"n_rows":48,"n_cols":6,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[]
["Category","SubCategory1","Category-SubCategory1","SubCategory2",null,"Eligible Items"]
["Emergency Shelter","Essential Services","ESES","ESES-Case management",null,"Case management"]
["Emergency Shelter","Essential Services","ESES","ESES-Transportation",null,"Transportation"]
["Emergency Shelter","Operations","ESOP","ESOP-Maintenance",null,"Maintenance"]
["Emergency Shelter","Operations","ESOP","ESOP-Case Management/Staff Cost",null,"Case Management/Staff Cost"]
["Emergency Shelter","Operations","ESOP","ESOP-Rent",null,"Rent"]
["Emergency Shelter","Operations","ESOP","ESOP-Security",null,"Security"]
["Emergency Shelter","Operations","ESOP","ESOP-Fuel",null,"Fuel"]
["Emergency Shelter","Operations","ESOP","ESOP-Equipment",null,"Equipment"]
["Emergency Shelter","Operations","ESOP","ESOP-Insurance/Professional Services",null,"Insurance/Professional Services"]
["Emergency Shelter","Operations","ESOP","ESOP-Utilities",null,"Utilities"]
["Emergency Shelter","Operations","ESOP","ESOP-Food",null,"Food"]
["Emergency Shelter","Operations","ESOP","ESOP-Furnishings",null,"Furnishings"]
["Emergency Shelter","Operations","ESOP","ESOP-Supplies for shelter",null,"Supplies for shelter"]
["Emergency Shelter","Operations","ESOP","ESOP-Hotel/Motel Vouchers",null,"Hotel/Motel Vouchers"]
["Street Outreach","Essential Services","SOES","SOES-Engagement/Case Management/Transportation",null,"Engagement/Case Management/Transportation"]
["Rapid Rehousing","Expenditures for Rental Assistance","RRRA","RRRA-Rental payment",null,"Rental payment"]
["Rapid Rehousing","Expenditures for Rental Assistance","RRRA","RRRA-Rental arrearage payment",null,"Rental arrearage payment"]
["Rapid Rehousing","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","RRFA","RRFA-Rental application fees",null,"Rental application fees"]
["Rapid Rehousing","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","RRFA","RRFA-Security deposits",null,"Security deposits"]
["Rapid Rehousing","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","RRFA","RRFA-Last month rent",null,"Last month rent"]
["Rapid Rehousing","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","RRFA","RRFA-Utility deposit",null,"Utility deposit"]
["Rapid Rehousing","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","RRFA","RRFA-Utility payment",null,"Utility payment"]
["Rapid Rehousing","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","RRFA","RRFA-Moving costs",null,"Moving costs"]
["Rapid Rehousing","Expenditures for Housing Relocation and Stabilization Services - Services","RRSS","RRSS-Housing stability case management",null,"Housing stability case management"]
["Rapid Rehousing","Expenditures for Housing Relocation and Stabilization Services - Services","RRSS","RRSS-Housing search",null,"Housing search"]
["Rapid Rehousing","Expenditures for Housing Relocation and Stabilization Services - Services","RRSS","RRSS-Placement",null,"Placement"]
["Homeless Prevention","Expenditures for Rental Assistance","HPRA","HPRA-Rental payment",null,"Rental payment"]
["Homeless Prevention","Expenditures for Rental Assistance","HPRA","HPRA-Rental arrearage payment",null,"Rental arrearage payment"]
["Homeless Prevention","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","HPFA","HPFA-Rental application fees",null,"Rental application fees"]
["Homeless Prevention","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","HPFA","HPFA-Security Deposit",null,"Security Deposit"]
["Homeless Prevention","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","HPFA","HPFA-Last month rent",null,"Last month rent"]
["Homeless Prevention","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","HPFA","HPFA-Utility deposit",null,"Utility deposit"]
["Homeless Prevention","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","HPFA","HPFA-Utility payment",null,"Utility payment"]
["Homeless Prevention","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","HPFA","HPFA-Moving Cost",null,"Moving Cost"]
["Homeless Prevention","Expenditures for Housing Relocation and Stabilization Services - Services","HPSS","HPSS-Housing stability case management",null,"Housing stability case management"]
["Homeless Prevention","Expenditures for Housing Relocation and Stabilization Services - Services","HPSS","HPSS-Housing search",null,"Housing search"]
["Homeless Prevention","Expenditures for Housing Relocation and Stabilization Services - Services","HPSS","HPSS-Placement",null,"Placement"]
["HMIS","Homeless Management Information System","HMIS","HMIS-Data support",null,"Data support"]
["MATCH","Other Non-ESG HUD funds","MATCH-Other Non-ESG Funds","MATCH-Other Non-ESG Funds",null,"Other Non-ESG Funds"]
["MATCH","Other Federal Funds","MATCH-Other Federal Funds","MATCH-Other Federal Funds",null,"Other Federal Funds"]
["MATCH","State Government","MATCH-State Government","MATCH-State Government",null,"State Government"]
["MATCH","Local Government","MATCH-Local Government","MATCH-Local Government",null,"Local Government"]
["MATCH","Private Funds","MATCH-Private Funds","MATCH-Private Funds",null,"Private Funds"]
["MATCH","Other-Volunteer Hours","MATCH-Other Volunteer Hours","MATCH-Other Volunteer Hours",null,"Other Volunteer Hours"]
["MATCH","Other-In Kind Donations","MATCH-In-Kind Donations","MATCH-In-Kind Donations",null,"Other-In Kind Donations"]
["MATCH","Other-Donated value","MATCH-Other-Donated value","MATCH-Other-Donated value",null,"Other-Donated value"]